[madmatt2006]

Hi Members

Needed a little help on an access program I'm working on for PCHHQ it uses the DoCmd.TransferSpreadsheet to export or import data. It's run off a button on a form with this code

this is the export code it works
Private Sub Command0_Click()
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "Data Feed Query", "D:\ExportData.xls"
MsgBox ("Done!")
End Sub

this is the problem code for import
Private Sub Command2_Click()
DoCmd.TransferSpreadsheet acImportDelim, acSpreadsheetTypeExcel12, "Data Feed", "C:\DataFeed\Data Feed.txt", False
End Sub


I get this error
run time error 3274
I get an error "Run-time error '3274': External table isn't in the expected format" ...

I have saved the file that is getting imported as txt tab delimited. So I'm a little stuck any ideas?

[Uncle Fester]

I'll have a look at it tomorrow, must admit my first foray into VB was a front end for an Access db (a lending library) so do have some exp there. Will try to duplicate the error and see if can find a way thru. Bit late for me now -nearly 2 am and got work in am. See what I can do..

'Once I had a life, now I have a computer'

[noop]

Uncle Fester, on 17 September 2009 - 12:49 AM, said:

'Once I had a life, now I have a computer'

Lol, I sadly am in that same boat.

As for the problem. You need it to be an excel file, not text. Hence, .txt should be .xls

[Uncle Fester]

Just a thought - can you send me examples of the exported file and the one to be imported. Use This Address as others often fill up with *stuff*, plus I get a lot of newsletters from MS and others - won't have to wade through looking for it. Never used 07 too, will install it tom on my programming PC.

Noop's point is a good one, bit late at night for me and should have noticed it. What you can do is convert the tab delimited file to a spreadsheet in code by importing to excel(will find you a snippet) before importing it

[madmatt2006]

Yay all working this code. I would have sent over Uncle Fester but too big

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "Data Feed", "C:\DataFeed\DataFeed.xls", True
MsgBox ("Done Importing!")

had error because file was not saved in proper format.

[Uncle Fester]

Bet you're a happy bunny now! Well done to noop for picking up on that, should have seen that too, too busy thinking about bed. Laters...

[madmatt2006]

Later my friend have a great sleep!