The table you want to import should be turned into a regular sequential file by "exporting" from Access. When you export, be careful of some things.
1. The default export for most Microsoft products is a comma delimited file (*.CSV). If you export with this it looks like "fielda","fieldb","fieldc"... for every row in your Access table. This is ok for importing into links, but you have to be careful. If your data contains apostrophes, double quotes, commas, etc. you could get into trouble.
2. The best way to export, as a rule, is to go through the Access Export wizard and change delimited file to: delimited by '|' (that's the character above the "\") on your keyboard. The idea here is that this character is rarely used and most likely will not be found in your file.
3. Save the file somewhere on your harddrive as a *.txt file.
4. Follow the Links procedure for importing. Open up Notepad with your *.txt file in it, select all and do a cut and paste into the links import box.
5. You may have a problem if you have limited memory on your machine.
6. There may be better ways to get the file into Links and maybe someone else can post that here. The procedure to get the file out of access is a good one, I think.
1. The default export for most Microsoft products is a comma delimited file (*.CSV). If you export with this it looks like "fielda","fieldb","fieldc"... for every row in your Access table. This is ok for importing into links, but you have to be careful. If your data contains apostrophes, double quotes, commas, etc. you could get into trouble.
2. The best way to export, as a rule, is to go through the Access Export wizard and change delimited file to: delimited by '|' (that's the character above the "\") on your keyboard. The idea here is that this character is rarely used and most likely will not be found in your file.
3. Save the file somewhere on your harddrive as a *.txt file.
4. Follow the Links procedure for importing. Open up Notepad with your *.txt file in it, select all and do a cut and paste into the links import box.
5. You may have a problem if you have limited memory on your machine.
6. There may be better ways to get the file into Links and maybe someone else can post that here. The procedure to get the file out of access is a good one, I think.
